---------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Dropbox\bavarian affair\merged data\replication\continuous_indicator.lo
> g
  log type:  text
 opened on:  19 Nov 2015, 16:30:28

. 
. ren *Zeitung* *Z*

. ren *Nachrichten* *N*

. ren *Nachri* *N*

. ren *Presse* *P*

. ren *Tageblatt* *T*

. ren *Tag* *T*

. ren Süddeutsche* S*

. ren *Rundschau* *R*

. ren MünchnerAbendzei* MünchnerAZ*

. 
. 
. foreach v of var Summe-SZ_aff {
  2. qui sum `v'
  3. gen `v'_insd = `v'/r(sd)
  4. }

. 
. cor *aff_insd //  Neumarkter, Nordbayer, Erlanger different
(obs=24)

             | SummeA~d Bayeri~d Coburg~d DIEKIT~d Erlang~d Franke~dFränki~d MainPo~d
-------------+------------------------------------------------------------------------
SummeAlle_~d |   1.0000
Bayerische~d |   0.9721   1.0000
CoburgerT_~d |   0.9721   1.0000   1.0000
DIEKITZING~d |   0.9562   0.9731   0.9731   1.0000
ErlangerN_~d |  -0.0883  -0.0934  -0.0934  -0.0851   1.0000
Frankenpos~d |   0.8339   0.7712   0.7712   0.7873  -0.1722   1.0000
Fränkische~d |   0.8568   0.8778   0.8778   0.8725   0.2984   0.6123   1.0000
MainPost_a~d |   0.8351   0.8147   0.8147   0.8446  -0.1612   0.6517   0.6983   1.0000
MünchnerAZ~d |   0.9419   0.8757   0.8757   0.8989  -0.2041   0.8854   0.7008   0.7567
NeuePFacti~d |   0.8861   0.7990   0.7990   0.7534  -0.1460   0.8540   0.6641   0.6933
Neumarkter~d |  -0.1513  -0.1539  -0.1539  -0.1647  -0.0629  -0.1191  -0.1651  -0.1115
Nordbayeri~d |   0.0132   0.0248   0.0248   0.0471   0.6916  -0.1191   0.4788  -0.1115
Nürnberger.. |   0.9649   0.9163   0.9163   0.8818  -0.0965   0.7672   0.7866   0.7245
N~Z_aff_insd |   0.9372   0.8854   0.8854   0.9054   0.0357   0.7153   0.8625   0.8280
PassauerNe~d |   0.7856   0.7406   0.7406   0.6768  -0.1443   0.6376   0.5783   0.6422
SaaleZ_aff~d |   0.9750   0.9933   0.9933   0.9847  -0.0860   0.7828   0.8845   0.8353
SZOnline_a~d |   0.8703   0.8015   0.8015   0.7868  -0.0414   0.9264   0.7233   0.6792
 SZ_aff_insd |   0.9853   0.9536   0.9536   0.9226  -0.1742   0.7841   0.7928   0.8275

             |Münchn~d NeuePF~d Neumar~d Nordba~dNürnbe..Nürnbe.. Passau~d SaaleZ~d
-------------+------------------------------------------------------------------------
MünchnerAZ~d |   1.0000
NeuePFacti~d |   0.8830   1.0000
Neumarkter~d |  -0.1412  -0.1010   1.0000
Nordbayeri~d |  -0.1412  -0.1010  -0.0435   1.0000
Nürnberger.. |   0.9350   0.9038  -0.1088  -0.0246   1.0000
N~Z_aff_insd |   0.8658   0.8231  -0.1481   0.1481   0.9151   1.0000
PassauerNe~d |   0.7126   0.6552  -0.1530  -0.0998   0.7470   0.6521   1.0000
SaaleZ_aff~d |   0.8928   0.8037  -0.1615   0.0425   0.9164   0.9107   0.7078   1.0000
SZOnline_a~d |   0.8658   0.8884  -0.1146   0.0573   0.8303   0.7969   0.6221   0.8176
 SZ_aff_insd |   0.9338   0.8833  -0.1524  -0.0885   0.9722   0.9123   0.7970   0.9506

             | SZOnli~d SZ_aff~d
-------------+------------------
SZOnline_a~d |   1.0000
 SZ_aff_insd |   0.8242   1.0000


. spearman *_aff_insd  // very similar
(obs=24)

             | SummeA~d Bayeri~d Coburg~d DIEKIT~d Erlang~d Franke~d Fränki~d MainPo~d
-------------+------------------------------------------------------------------------
SummeAlle_~d |   1.0000 
Bayerische~d |   0.8776   1.0000 
CoburgerT_~d |   0.8776   1.0000   1.0000 
DIEKITZING~d |   0.8886   0.9857   0.9857   1.0000 
ErlangerN_~d |   0.0437  -0.0714  -0.0714  -0.0719   1.0000 
Frankenpos~d |   0.8521   0.8779   0.8779   0.9086  -0.2255   1.0000 
Fränkische~d |   0.8701   0.8997   0.8997   0.8919   0.2722   0.7504   1.0000 
MainPost_a~d |   0.8220   0.8342   0.8342   0.8495  -0.2079   0.9219   0.7139   1.0000 
MünchnerAZ~d |   0.8566   0.8877   0.8877   0.9231  -0.2256   0.9885   0.7631   0.9006 
NeuePFacti~d |   0.8298   0.8081   0.8081   0.8467  -0.2079   0.9508   0.7007   0.8647 
Neumarkter~d |  -0.1360  -0.1810  -0.1810  -0.1822  -0.0629  -0.1559  -0.2196  -0.1438 
Nordbayeri~d |   0.0756   0.0823   0.0823   0.0828   0.6916  -0.1559   0.3294  -0.1438 
Nürnberger.. |   0.8726   0.8521   0.8521   0.8592   0.0567   0.8582   0.8030   0.7925 
N~Z_aff_insd |   0.9563   0.8848   0.8848   0.8999   0.1680   0.8102   0.8943   0.8082 
PassauerNe~d |   0.8942   0.8405   0.8405   0.8381  -0.1149   0.8818   0.7726   0.8384 
SaaleZ_aff~d |   0.8751   0.9700   0.9700   0.9715  -0.0819   0.8728   0.8679   0.8316 
SZOnline_a~d |   0.7917   0.7290   0.7290   0.7968   0.0521   0.8432   0.7228   0.8378 
 SZ_aff_insd |   0.9259   0.8725   0.8725   0.8747  -0.1146   0.8790   0.8082   0.8490 

             | Münchn~d NeuePF~d Neumar~d Nordba~d Nürnbe.. Nürnbe.. Passau~d SaaleZ~d
-------------+------------------------------------------------------------------------
MünchnerAZ~d |   1.0000 
NeuePFacti~d |   0.9556   1.0000 
Neumarkter~d |  -0.1560  -0.1438   1.0000 
Nordbayeri~d |  -0.1560  -0.1438  -0.0435   1.0000 
Nürnberger.. |   0.8793   0.8338   0.0000   0.0784   1.0000 
N~Z_aff_insd |   0.8243   0.7730  -0.1704   0.2169   0.8897   1.0000 
PassauerNe~d |   0.8736   0.8542  -0.3179  -0.0795   0.7778   0.8528   1.0000 
SaaleZ_aff~d |   0.8921   0.8129  -0.1942   0.0809   0.8366   0.8841   0.8402   1.0000 
SZOnline_a~d |   0.8377   0.8716  -0.1441   0.2161   0.7805   0.8140   0.7546   0.7555 
 SZ_aff_insd |   0.8895   0.8493  -0.2060   0.0475   0.8760   0.8779   0.8747   0.8547 

             | SZOnli~d SZ_aff~d
-------------+------------------
SZOnline_a~d |   1.0000 
 SZ_aff_insd |   0.7894   1.0000 

. 
. drop  NeumarkterN* NordbayerischeN* ErlangerN*

. drop SummeAlle*

. 
. egen affair_cont = rmean(*_aff_insd)

. 
. gsort -affair_cont 

. list name affair_cont 

     +------------------------+
     |        name   affair~t |
     |------------------------|
  1. |     GSchmid   3.598098 |
  2. |     GWinter   1.897642 |
  3. |        GEck   1.802307 |
  4. |    HBrunner   1.550023 |
  5. |     BSibler   1.413515 |
     |------------------------|
  6. |    LSpaenle   1.373625 |
  7. |       AKnig   1.352691 |
  8. |       BMerk   1.040633 |
  9. |  FPschierer   .9226095 |
 10. |        ENth   .7304733 |
     |------------------------|
 11. |        MWei   .1540189 |
 12. |    CMatschl   .0983075 |
 13. |     ERotter    .097226 |
 14. |     WNadler   .0670796 |
 15. |     RKiesel   .0572059 |
     |------------------------|
 16. |     HRudrof   .0510103 |
 17. |    OZeitler   .0504696 |
 18. |    MStrehle   .0344002 |
 19. | JUnterlnder   .0344002 |
 20. |     PSchmid   .0344002 |
     |------------------------|
 21. |   KEckstein   .0306871 |
 22. |    AFracker   .0306871 |
 23. |        TRei          0 |
 24. |        BRth          0 |
     +------------------------+

. 
. log close
      name:  <unnamed>
       log:  C:\Dropbox\bavarian affair\merged data\replication\continuous_indicator.lo
> g
  log type:  text
 closed on:  19 Nov 2015, 16:30:29
---------------------------------------------------------------------------------------
